<?xml version="1.0" encoding="utf-8" ?>
<sqlMap namespace="RStaffRoles" xmlns="http://ibatis.apache.org/mapping" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<statements>
<select id="SelectRStaffRoles_PC" parameterClass="System.Collections.IDictionary" resultClass="int">
SELECT COUNT(*)
FROM r_staff_roles
<include refid="sql_RStaffRoles_where_cv"/>
</select>

<select id="SelectRStaffRoles_PG" parameterClass="System.Collections.IDictionary" resultMap="RStaffRoles.select-rstaffroles-result">
SELECT *
FROM r_staff_roles
<include refid="sql_RStaffRoles_where_cv"/> limit $_offset$,$_rows$
</select>
</statements>
</sqlMap>